﻿CREATE TABLE [dbo].[EmployeeQualifications]
(
	[Id] int IDENTITY(1,1) NOT NULL,
	[EmployeeId] [int] NOT NULL,
	[Institute] [varchar](100) NULL,
	[PercentSecured] [varchar](30) NULL,
	[BoardUniv] [varchar](100) NULL,
	[Major] [varchar](75) NULL,
	[IsFullTime] [bit] NULL,
	[QualFromDate] [smalldatetime] NULL,
	[QualToDate] [smalldatetime] NULL,
	[Yearofpass] [int] NULL,
	[Remarks] [varchar](250) NULL,
	[TxnCrUser]         VARCHAR (20) NULL, 
	[TxnCrDate]         DATETIME     NULL,
	[TxnUser]           VARCHAR (20)  NULL,
	[Txndate]           DATETIME     NULL
)
go
ALTER TABLE [dbo].[EmployeeQualifications]
	ADD CONSTRAINT [PK_EmployeeQualifications]
	PRIMARY KEY ([ID])
